Tabela ExcludedContractService

Definicja tabeli ExcludedContractService

Name

ExcludedContractService

Code

ExcludedContractService

Comment

Tabela zawiera informacje o zablokowanych produktach jednostkowych dla produktu
kontraktowego w danym czasie


Lista kolumn tabeli ExcludedContractService

Name

Code

ExcludedContractServiceID

ExcludedContractServiceID

ContractID

ContractID

ContractServID

ContractServID

Con_ContractServID

Con_ContractServID

StartDT

StartDT

StopDT

StopDT


Kolumna ExcludedContractServiceID tabeli ExcludedContractService

Definicja kolumny ExcludedContractServiceID tabeli ExcludedContractService

Name

ExcludedContractServiceID

Code

ExcludedContractServiceID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna ContractID tabeli ExcludedContractService

Definicja kolumny ContractID tabeli ExcludedContractService

Name

ContractID

Code

ContractID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna ContractServID tabeli ExcludedContractService

Definicja kolumny ContractServID tabeli ExcludedContractService

Name

ContractServID

Code

ContractServID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna Con_ContractServID tabeli ExcludedContractService

Definicja kolumny Con_ContractServID tabeli ExcludedContractService

Name

Con_ContractServID

Code

Con_ContractServID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna StartDT tabeli ExcludedContractService

Definicja kolumny StartDT tabeli ExcludedContractService

Name

StartDT

Code

StartDT

Data Type

DATE

Mandatory

No

Comment

 


Kolumna StopDT tabeli ExcludedContractService

Definicja kolumny StopDT tabeli ExcludedContractService

Name

StopDT

Code

StopDT

Data Type

DATE

Mandatory

No

Comment

 


Lista kluczy tabeli ExcludedContractService

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli ExcludedContractService

Definicja klucza Identifier_1 tabeli ExcludedContractService

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment